package com.authine.cloudpivot.web.api.secondopen.dao;

import com.authine.cloudpivot.web.api.secondopen.domain.Ie6s6cbzxwhjcxx;
import com.authine.cloudpivot.web.api.secondopen.vo.BudgetVO;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;


import java.util.List;
@Repository
public interface Ie6s6cbzxwhjcxxMapper {
    /**
     * 同步成本中心
     * @param ie6s6cbzxwhjcxxe
     * @return
     */
    public int insertCCtoBPM(@Param("ie6s6cbzxwhjcxxe") List<Ie6s6cbzxwhjcxx> ie6s6cbzxwhjcxxe);

    /**
     * 查询费用类型
     * @param cbzx
     * @param nf
     * @param yf
     * @return
     */
    public List<BudgetVO> queryBudget(@Param("cbzx") String cbzx,@Param("nf") int nf,@Param("yf") int yf);

    /**
     * 根据年、月、成本中心、一级科目、二级科目，查询月累计
     */
    public BudgetVO queryParams(@Param("nf") int nf,
                                      @Param("yf") int yf,
                                      @Param("cbzx") String cbzx,
                                      @Param("onesub") String onesub,
                                      @Param("twosub") String twosub);

    public int insertBudget(@Param("budgetVOList") List<BudgetVO> budgetVOList);
}